import MySQLdb

conn = MySQLdb.connect(
    host='192.168.1.65',
    port=3306,
    user='pump',
    passwd='Pump_123',
    db='pump',
    charset='utf8'
    )

cur = conn.cursor()

DB_NAME = 'pumptest'
cur.execute('CREATE DATABASE IF NOT EXISTS baogang')
#cur.execute('DROP DATABASE IF EXISTS pumptest')


cur.close()

conn.close()


